package com.pureut.storage.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pureut.storage.domain.PickingCompleteDetail;
import com.pureut.storage.dto.NewPickingCompleteDetailDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 销售发货mapper
 * @author: CM
 * @date: 2022/12/27    14:54
 */
@Mapper
public interface PickingCompleteDetailMapper extends BaseMapper<PickingCompleteDetail> {

    /**
     * 返工出库查询列表
     * @param docNum
     * @return
     */
    List<NewPickingCompleteDetailDto> getpickingComPleteDetailList(@Param("docNum") String docNum );

    /**
     * 根据批号查询总重量
     * @param inputValue
     * @return
     */
    Double getPiHao(@Param("inputValue") String inputValue);

    /**
     * 根据单据号查出总重量
     * @param inputValue
     * @return
     */
    Double getDoc(@Param("inputValue") String inputValue);

    /**
     * 查询当前批次号在明细中的总重量
     * @param inputValue
     * @return
     */
    Double getNetWeight(@Param("inputValue") String inputValue,@Param("docNum") String docNum);

    /**
     * 获取反攻出库的库位信息
     * @param id
     * @return
     */
    PickingCompleteDetail getKw(Long id);
}
